{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "%matplotlib inline\n",
    "\n",
    "np.random.seed(42)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "INPUT_PATH = '../input/'\n",
    "CACHE_PATH = '../cache/'\n",
    "OUTPUT_PATH ='../output/'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df_train = pd.read_csv(INPUT_PATH + 'train_second.csv') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df_train_first = pd.read_csv(INPUT_PATH+'train_first.csv')\n",
    "df_train = pd.concat([df_train,df_train_first],axis = 0).reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Id</th>\n",
       "      <th>Discuss</th>\n",
       "      <th>Score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4c6d4f1c-3e7e-3653-8cd4-a7aa922f2063</td>\n",
       "      <td>景点没啥值得看的，山上都是石头，最最重要的是山上没有风，大热天去热死个人</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>b2c9c1ec-c283-380f-a584-bb29895e561e</td>\n",
       "      <td>去厦门必须去的一个地方，景色很好。</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5e0b58f1-35db-3f02-b4b8-ef596da70b17</td>\n",
       "      <td>一条很窄很窄的弄堂 去的时候夜色已深 有种恐怖片的既视感</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>e3f71f80-6224-3d15-86e2-e3c8aa547ba5</td>\n",
       "      <td>荷花市场的牌匾在后海那一块 里面也没什么特别的 很多都是卖吃的</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7093c5af-36fa-37a0-a0b8-057bf8c5a628</td>\n",
       "      <td>不错</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>dbdd8702-4c21-377b-bf0d-2af685885a7f</td>\n",
       "      <td>有好有不足</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2d357f60-f137-3df5-9dae-24f92846ab5b</td>\n",
       "      <td>名气大，山上常有浓雾，登顶后一片朦胧，有点失落</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>e7ceccf2-5b8a-3b7b-8b31-6f9b2c0d7983</td>\n",
       "      <td>还可以</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9bae3c25-3379-34ea-88e0-f8e36481de28</td>\n",
       "      <td>跨海大桥真的很经典，宁波与嘉兴之间的杭州湾，说是海，那海泥巴多的简直夸张。。。钱塘江出海口，...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>52e30c81-c15c-3938-a9ff-3465d29c2c93</td>\n",
       "      <td>公园还在建设，相信将来会越来越好。只是道路指示不是很清晰，需要打听才知道如何去。</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>d4a356fd-1c4c-3a83-8629-6597b12545b1</td>\n",
       "      <td>10月3号到的，感觉人不算特别多，可能天气不太好吧，随时会下雨，索道排队半个小时，能接受</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>45c10b48-ef0d-378c-a25e-3d4fafd08968</td>\n",
       "      <td>风景漂亮，值得一游，有机会的话再去一次 1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>4584504d-26a7-315c-b683-c9739df0aa70</td>\n",
       "      <td>不错</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>9f9af251-41cc-388e-80b3-bdbd1503a784</td>\n",
       "      <td>来了北京长城不来怎么行，不到长城非好汉，有专线直接到</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>e40cc7e8-9b7e-3b7f-9891-ccdae708a433</td>\n",
       "      <td>几年前和同期的朋友们去度假玩的，还不错吧。有种老革命根据地的feel</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>d01421f6-ce3d-3c00-b517-102c24c23336</td>\n",
       "      <td>北京后花园在白虎涧风景区，面积较大，只按景区指示选择了路线三游览，走过后发现其中“通天八十一...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>bec72939-90a9-32aa-b09f-e5e618b0e959</td>\n",
       "      <td>张静江故居位于湖州市南浔镇。全国重点文物保护单位。张静江故居，又名尊德堂。系张静江祖父张颂贤...</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>21974dea-2865-300b-8139-fea662b8aac2</td>\n",
       "      <td>人挤人气死人！</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>7783dad9-81f6-372a-9f96-54db8f55b7e7</td>\n",
       "      <td>很酷</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>25ff9af4-4831-33ca-8bc1-38de20441487</td>\n",
       "      <td>扬州的标志性景点，门票有的略贵，但是值得一去，里面有许多小景点。</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>6b6cd4ba-70a6-30ef-963d-58bac4a41bf6</td>\n",
       "      <td>交通便利，动物种类多，节目精彩</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>d97d438d-12da-31a5-ae9c-15c343bbeb87</td>\n",
       "      <td>美丽的风景，像人间仙境，值得一游。</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>4208931a-0cef-34e5-a2e8-6702d5147696</td>\n",
       "      <td>明明做了桥的攻略，到那边就全忘了</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>c965f5a3-f100-3130-b3ec-16900daf62c7</td>\n",
       "      <td>作为中国最著名的山岳之一，是人生必去的目的地之一。我去的时候，运气很好，恰逢雪后天晴。整个泰...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>5c3aebd3-6a1b-329e-8ab4-c8c396aaf299</td>\n",
       "      <td>演出</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>e61e9c26-7878-3a43-97d7-598646f94376</td>\n",
       "      <td>很好，很大，氛围很好，难得的一种与世隔绝之处</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>7f75dcbc-13b1-36a6-8ff0-44b89732b164</td>\n",
       "      <td>三清山真的是我去过的最漂亮最难忘的山，也是最有仙气的一座山。直接坐五分多钟的缆车到达一千四百...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>ffce1d1e-0c36-3078-97a5-05d7a2cc48da</td>\n",
       "      <td>特别震撼，真的是觉得鬼斧神工，</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>af9c29a3-807b-3e58-a902-d48bf32a8472</td>\n",
       "      <td>还行吧</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>5f280b41-22ad-34d0-b138-07c5788173e7</td>\n",
       "      <td>天子山是个人认为张家界里景色最好的地方，尤其是神堂湾和点将台，没有旅行团去，根本没有人，景色...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219970</th>\n",
       "      <td>a3dee0f1-d4bd-3d4d-8995-e1b58b3257a1</td>\n",
       "      <td>这里是老北京的一部分，可以很好的体会下北京的市井风情</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219971</th>\n",
       "      <td>c865e80c-aba9-37fc-a8b1-c14379a6c27d</td>\n",
       "      <td>那拉提草原不像呼伦贝尔大草原那样广阔，草原大多有小山包，有些地方还有些原始丛林 ，也算是体验...</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219972</th>\n",
       "      <td>d7bc54b0-41d9-3385-b8b5-c4c46aa57a6f</td>\n",
       "      <td>还不错，小孩子了挺喜欢的。 体验了6种职业，还不错，挺开心的，继续</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219973</th>\n",
       "      <td>baa94618-9a68-33cb-8acc-193d103ed9ae</td>\n",
       "      <td>今年国庆节我和爱人一起去的烂柯山旅游的 风景可以吧 人气不错 虽然没有任何游乐设施 但是就凭...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219974</th>\n",
       "      <td>37ec5147-2b75-36e9-899a-626dd27a4a0f</td>\n",
       "      <td>我们到清华园下车，我本来以为清华园就在清华边上，其实要走蛮远的。不过我们还是用步行的，从清华...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219975</th>\n",
       "      <td>e07845c0-3376-3f65-839f-74f507fd69d7</td>\n",
       "      <td>雨中湿地</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219976</th>\n",
       "      <td>fd74533b-f531-3880-b5f9-012dcb209b26</td>\n",
       "      <td>说实话..对秦皇岛蛮失望的..老龙头的建筑完全没啥亮点，走到哪里都在施工，尘土飞扬，呼吸都不...</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219977</th>\n",
       "      <td>40b0815a-64bd-3601-83b8-656c3a3c3512</td>\n",
       "      <td>有意义的旅行。</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219978</th>\n",
       "      <td>028116c0-a852-3902-a54e-08c9dfffb5f6</td>\n",
       "      <td>总体很棒，山景也很美，正好碰到了阳光云雾下雨再出太阳</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219979</th>\n",
       "      <td>4ae52f48-c097-3ee1-bb74-754f41545626</td>\n",
       "      <td>感觉还不错，泰山值得一去，就是天气不太好，没有看到日出有点遗憾！</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219980</th>\n",
       "      <td>2d5f686e-fb5a-304a-ad85-c2fe202031dd</td>\n",
       "      <td>好玩</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219981</th>\n",
       "      <td>ca32d86a-672c-3d7a-83b7-b33c7cb0edc2</td>\n",
       "      <td>很小~很无聊~建议大家千万别去</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219982</th>\n",
       "      <td>5a60c901-93f4-34ca-b047-825f8a9220cc</td>\n",
       "      <td>去的第一个水乡，还好，意境不错，风景也不错，可惜地方不大</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219983</th>\n",
       "      <td>3a8e259e-e56d-3ea1-881d-0964e08574b7</td>\n",
       "      <td>溪口必去景点噢~哈哈，拗造型最佳~</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219984</th>\n",
       "      <td>15af3046-9092-3705-b489-2021a87e9da4</td>\n",
       "      <td>戒台寺一日游</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219985</th>\n",
       "      <td>7a4bfa2c-894d-39c7-bd9f-00d0c3776686</td>\n",
       "      <td>典型的江南水乡古镇，小桥流水人家的特点体现无疑。有时景区还会有传统婚俗表演，载着被子等生活用...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219986</th>\n",
       "      <td>ddd916e3-a80a-3829-ab5a-5e98b43b412e</td>\n",
       "      <td>小时候去八一射击场必经之路，桥上的狮子各不相同要慢慢欣赏。</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219987</th>\n",
       "      <td>38321ea3-c3f5-3ce9-8ece-e1c0ab689571</td>\n",
       "      <td>风景还是很不错的，可以直接走近青海湖，还可以下水拍照，建议可以游玩2-3小时</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219988</th>\n",
       "      <td>54349b10-6d90-32a8-b1be-2b5640ea80dc</td>\n",
       "      <td>刚进来，景色不错的，听着虫鸣，我觉得夜晚应该会更舒心。湖中鸳鸯「鸭子」戏水。感觉还是可以的</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219989</th>\n",
       "      <td>f1467a75-1af4-306d-83ab-b2690f13b7f7</td>\n",
       "      <td>周末休闲游</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219990</th>\n",
       "      <td>36834a7f-2383-3982-b107-847224f6d88f</td>\n",
       "      <td>只有3D美术馆不需买票，其余体验的全需要买票，而且价格很高，不推荐大家购买！</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219991</th>\n",
       "      <td>586b3aed-50e9-3360-ae51-511e9bd070e8</td>\n",
       "      <td>瘦西湖去过几次了，典型的江南风光</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219992</th>\n",
       "      <td>62e48713-2d5f-3ed9-a6d1-29e70fa1929d</td>\n",
       "      <td>兵马俑不用说，西安必须去的景点了</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219993</th>\n",
       "      <td>58c15e36-0fc8-3a06-83ac-b39acf63f0d1</td>\n",
       "      <td>这里很少人来，路都长青苔了，如果不是结伴玩一个人最好不要来，这里比较原始，要注重安全，要不然...</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219994</th>\n",
       "      <td>4699e810-7f22-3bc5-99b5-9bb2384c5a82</td>\n",
       "      <td>好！</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219995</th>\n",
       "      <td>974ccfad-d6f9-38f5-918a-a12759ee1082</td>\n",
       "      <td>世界公园里有各种各样的东西，拍照很不错</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219996</th>\n",
       "      <td>0902ff7b-f038-382d-a183-cbd500f5c544</td>\n",
       "      <td>乐山大佛很壮观，值得一去的地方。</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219997</th>\n",
       "      <td>2ac377d7-30ad-344a-a54f-e0d6ed64218e</td>\n",
       "      <td>凌晨两三点出发去看升旗，那天还下着小雨，五点左右到的时候，已经里三层外三层站满了人，大家都是...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219998</th>\n",
       "      <td>546fca83-da8a-3b04-8b3b-09281b29a020</td>\n",
       "      <td>大王峰不高,好爬,没有天游峰那么险,两个鼓起的山包,很适合休闲游,边聊天边慢慢地爬.</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219999</th>\n",
       "      <td>7cc3db2d-31da-3b3c-84b6-ed0f6fe50ec9</td>\n",
       "      <td>南海子公园占地很大，要想一天都在里面玩儿也可以，但是要自带食品，里面没有吃饭的地方，园区整体...</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>220000 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          Id  \\\n",
       "0       4c6d4f1c-3e7e-3653-8cd4-a7aa922f2063   \n",
       "1       b2c9c1ec-c283-380f-a584-bb29895e561e   \n",
       "2       5e0b58f1-35db-3f02-b4b8-ef596da70b17   \n",
       "3       e3f71f80-6224-3d15-86e2-e3c8aa547ba5   \n",
       "4       7093c5af-36fa-37a0-a0b8-057bf8c5a628   \n",
       "5       dbdd8702-4c21-377b-bf0d-2af685885a7f   \n",
       "6       2d357f60-f137-3df5-9dae-24f92846ab5b   \n",
       "7       e7ceccf2-5b8a-3b7b-8b31-6f9b2c0d7983   \n",
       "8       9bae3c25-3379-34ea-88e0-f8e36481de28   \n",
       "9       52e30c81-c15c-3938-a9ff-3465d29c2c93   \n",
       "10      d4a356fd-1c4c-3a83-8629-6597b12545b1   \n",
       "11      45c10b48-ef0d-378c-a25e-3d4fafd08968   \n",
       "12      4584504d-26a7-315c-b683-c9739df0aa70   \n",
       "13      9f9af251-41cc-388e-80b3-bdbd1503a784   \n",
       "14      e40cc7e8-9b7e-3b7f-9891-ccdae708a433   \n",
       "15      d01421f6-ce3d-3c00-b517-102c24c23336   \n",
       "16      bec72939-90a9-32aa-b09f-e5e618b0e959   \n",
       "17      21974dea-2865-300b-8139-fea662b8aac2   \n",
       "18      7783dad9-81f6-372a-9f96-54db8f55b7e7   \n",
       "19      25ff9af4-4831-33ca-8bc1-38de20441487   \n",
       "20      6b6cd4ba-70a6-30ef-963d-58bac4a41bf6   \n",
       "21      d97d438d-12da-31a5-ae9c-15c343bbeb87   \n",
       "22      4208931a-0cef-34e5-a2e8-6702d5147696   \n",
       "23      c965f5a3-f100-3130-b3ec-16900daf62c7   \n",
       "24      5c3aebd3-6a1b-329e-8ab4-c8c396aaf299   \n",
       "25      e61e9c26-7878-3a43-97d7-598646f94376   \n",
       "26      7f75dcbc-13b1-36a6-8ff0-44b89732b164   \n",
       "27      ffce1d1e-0c36-3078-97a5-05d7a2cc48da   \n",
       "28      af9c29a3-807b-3e58-a902-d48bf32a8472   \n",
       "29      5f280b41-22ad-34d0-b138-07c5788173e7   \n",
       "...                                      ...   \n",
       "219970  a3dee0f1-d4bd-3d4d-8995-e1b58b3257a1   \n",
       "219971  c865e80c-aba9-37fc-a8b1-c14379a6c27d   \n",
       "219972  d7bc54b0-41d9-3385-b8b5-c4c46aa57a6f   \n",
       "219973  baa94618-9a68-33cb-8acc-193d103ed9ae   \n",
       "219974  37ec5147-2b75-36e9-899a-626dd27a4a0f   \n",
       "219975  e07845c0-3376-3f65-839f-74f507fd69d7   \n",
       "219976  fd74533b-f531-3880-b5f9-012dcb209b26   \n",
       "219977  40b0815a-64bd-3601-83b8-656c3a3c3512   \n",
       "219978  028116c0-a852-3902-a54e-08c9dfffb5f6   \n",
       "219979  4ae52f48-c097-3ee1-bb74-754f41545626   \n",
       "219980  2d5f686e-fb5a-304a-ad85-c2fe202031dd   \n",
       "219981  ca32d86a-672c-3d7a-83b7-b33c7cb0edc2   \n",
       "219982  5a60c901-93f4-34ca-b047-825f8a9220cc   \n",
       "219983  3a8e259e-e56d-3ea1-881d-0964e08574b7   \n",
       "219984  15af3046-9092-3705-b489-2021a87e9da4   \n",
       "219985  7a4bfa2c-894d-39c7-bd9f-00d0c3776686   \n",
       "219986  ddd916e3-a80a-3829-ab5a-5e98b43b412e   \n",
       "219987  38321ea3-c3f5-3ce9-8ece-e1c0ab689571   \n",
       "219988  54349b10-6d90-32a8-b1be-2b5640ea80dc   \n",
       "219989  f1467a75-1af4-306d-83ab-b2690f13b7f7   \n",
       "219990  36834a7f-2383-3982-b107-847224f6d88f   \n",
       "219991  586b3aed-50e9-3360-ae51-511e9bd070e8   \n",
       "219992  62e48713-2d5f-3ed9-a6d1-29e70fa1929d   \n",
       "219993  58c15e36-0fc8-3a06-83ac-b39acf63f0d1   \n",
       "219994  4699e810-7f22-3bc5-99b5-9bb2384c5a82   \n",
       "219995  974ccfad-d6f9-38f5-918a-a12759ee1082   \n",
       "219996  0902ff7b-f038-382d-a183-cbd500f5c544   \n",
       "219997  2ac377d7-30ad-344a-a54f-e0d6ed64218e   \n",
       "219998  546fca83-da8a-3b04-8b3b-09281b29a020   \n",
       "219999  7cc3db2d-31da-3b3c-84b6-ed0f6fe50ec9   \n",
       "\n",
       "                                                  Discuss  Score  \n",
       "0                    景点没啥值得看的，山上都是石头，最最重要的是山上没有风，大热天去热死个人      3  \n",
       "1                                       去厦门必须去的一个地方，景色很好。      4  \n",
       "2                            一条很窄很窄的弄堂 去的时候夜色已深 有种恐怖片的既视感      4  \n",
       "3                         荷花市场的牌匾在后海那一块 里面也没什么特别的 很多都是卖吃的      3  \n",
       "4                                                      不错      4  \n",
       "5                                                   有好有不足      5  \n",
       "6                                 名气大，山上常有浓雾，登顶后一片朦胧，有点失落      3  \n",
       "7                                                     还可以      4  \n",
       "8       跨海大桥真的很经典，宁波与嘉兴之间的杭州湾，说是海，那海泥巴多的简直夸张。。。钱塘江出海口，...      5  \n",
       "9                公园还在建设，相信将来会越来越好。只是道路指示不是很清晰，需要打听才知道如何去。      3  \n",
       "10           10月3号到的，感觉人不算特别多，可能天气不太好吧，随时会下雨，索道排队半个小时，能接受      5  \n",
       "11                                  风景漂亮，值得一游，有机会的话再去一次 1      5  \n",
       "12                                                     不错      5  \n",
       "13                             来了北京长城不来怎么行，不到长城非好汉，有专线直接到      5  \n",
       "14                     几年前和同期的朋友们去度假玩的，还不错吧。有种老革命根据地的feel      4  \n",
       "15      北京后花园在白虎涧风景区，面积较大，只按景区指示选择了路线三游览，走过后发现其中“通天八十一...      5  \n",
       "16      张静江故居位于湖州市南浔镇。全国重点文物保护单位。张静江故居，又名尊德堂。系张静江祖父张颂贤...      3  \n",
       "17                                                人挤人气死人！      3  \n",
       "18                                                     很酷      5  \n",
       "19                       扬州的标志性景点，门票有的略贵，但是值得一去，里面有许多小景点。      4  \n",
       "20                                        交通便利，动物种类多，节目精彩      4  \n",
       "21                                      美丽的风景，像人间仙境，值得一游。      5  \n",
       "22                                       明明做了桥的攻略，到那边就全忘了      5  \n",
       "23      作为中国最著名的山岳之一，是人生必去的目的地之一。我去的时候，运气很好，恰逢雪后天晴。整个泰...      5  \n",
       "24                                                     演出      1  \n",
       "25                                 很好，很大，氛围很好，难得的一种与世隔绝之处      4  \n",
       "26      三清山真的是我去过的最漂亮最难忘的山，也是最有仙气的一座山。直接坐五分多钟的缆车到达一千四百...      5  \n",
       "27                                        特别震撼，真的是觉得鬼斧神工，      5  \n",
       "28                                                    还行吧      5  \n",
       "29      天子山是个人认为张家界里景色最好的地方，尤其是神堂湾和点将台，没有旅行团去，根本没有人，景色...      5  \n",
       "...                                                   ...    ...  \n",
       "219970                         这里是老北京的一部分，可以很好的体会下北京的市井风情      4  \n",
       "219971  那拉提草原不像呼伦贝尔大草原那样广阔，草原大多有小山包，有些地方还有些原始丛林 ，也算是体验...      3  \n",
       "219972                  还不错，小孩子了挺喜欢的。 体验了6种职业，还不错，挺开心的，继续      5  \n",
       "219973  今年国庆节我和爱人一起去的烂柯山旅游的 风景可以吧 人气不错 虽然没有任何游乐设施 但是就凭...      5  \n",
       "219974  我们到清华园下车，我本来以为清华园就在清华边上，其实要走蛮远的。不过我们还是用步行的，从清华...      4  \n",
       "219975                                               雨中湿地      5  \n",
       "219976  说实话..对秦皇岛蛮失望的..老龙头的建筑完全没啥亮点，走到哪里都在施工，尘土飞扬，呼吸都不...      2  \n",
       "219977                                            有意义的旅行。      5  \n",
       "219978                         总体很棒，山景也很美，正好碰到了阳光云雾下雨再出太阳      5  \n",
       "219979                   感觉还不错，泰山值得一去，就是天气不太好，没有看到日出有点遗憾！      5  \n",
       "219980                                                 好玩      5  \n",
       "219981                           很小~很无聊~建议大家千万别去      2  \n",
       "219982                       去的第一个水乡，还好，意境不错，风景也不错，可惜地方不大      4  \n",
       "219983                                  溪口必去景点噢~哈哈，拗造型最佳~      4  \n",
       "219984                                             戒台寺一日游      4  \n",
       "219985  典型的江南水乡古镇，小桥流水人家的特点体现无疑。有时景区还会有传统婚俗表演，载着被子等生活用...      5  \n",
       "219986                      小时候去八一射击场必经之路，桥上的狮子各不相同要慢慢欣赏。      4  \n",
       "219987             风景还是很不错的，可以直接走近青海湖，还可以下水拍照，建议可以游玩2-3小时      4  \n",
       "219988      刚进来，景色不错的，听着虫鸣，我觉得夜晚应该会更舒心。湖中鸳鸯「鸭子」戏水。感觉还是可以的      5  \n",
       "219989                                              周末休闲游      4  \n",
       "219990             只有3D美术馆不需买票，其余体验的全需要买票，而且价格很高，不推荐大家购买！      2  \n",
       "219991                                   瘦西湖去过几次了，典型的江南风光      5  \n",
       "219992                                   兵马俑不用说，西安必须去的景点了      5  \n",
       "219993  这里很少人来，路都长青苔了，如果不是结伴玩一个人最好不要来，这里比较原始，要注重安全，要不然...      4  \n",
       "219994                                                 好！      5  \n",
       "219995                                世界公园里有各种各样的东西，拍照很不错      4  \n",
       "219996                                   乐山大佛很壮观，值得一去的地方。      4  \n",
       "219997  凌晨两三点出发去看升旗，那天还下着小雨，五点左右到的时候，已经里三层外三层站满了人，大家都是...      5  \n",
       "219998         大王峰不高,好爬,没有天游峰那么险,两个鼓起的山包,很适合休闲游,边聊天边慢慢地爬.      4  \n",
       "219999  南海子公园占地很大，要想一天都在里面玩儿也可以，但是要自带食品，里面没有吃饭的地方，园区整体...      5  \n",
       "\n",
       "[220000 rows x 3 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5    0.605600\n",
       "4    0.280627\n",
       "3    0.099018\n",
       "2    0.009191\n",
       "1    0.005564\n",
       "Name: Score, dtype: float64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train['Score'].value_counts() / df_train.shape[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7f0601ca5ef0>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAD6CAYAAABOIFvoAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAEklJREFUeJzt3X+MZXV5x/H3w+7SbGdwu1YyFYL8\nSLZNqLjCTnVXFrxDgC61WktptKINRTOtWppqmjpGGqNRi43QBpTaaakQS52saRTpYkFbRrZ0URkt\nrrWt9sfSOBSpWZx1jH8YfPrHPfvdcZjde++5c+dcdt+vZMKZ53zPvc/9Zub72XPOnUtkJpIkAZzU\ndAOSpOFhKEiSCkNBklQYCpKkwlCQJBWGgiSpMBQkSUVXoRARYxGxd1nt+RHxmWp7Q0TcHREPRsS1\n/dYkSc3oGAoRsRm4AxhZUgvgJmBDVboOmMvMC4GrIuKUPmuSpAas72LMU8CrgLuW1H4DuB/4+er7\nFjBVbT8AjPdZu39pAxExCUwCbNy4cdsZZ5zRRdtP98Mf/pCTThq+K2b21Rv76t2w9mZfvemnr69/\n/evfzsxTO43rGAqZeQigfXIAEfGTwGtpB8LhUBgB5qvtg8BYn7XlPUwD0wDj4+P58MMPd2p7RbOz\ns7RarVrHDpJ99ca+ejesvdlXb/rpKyIe7WZcnci5AXh7Zv5gSW0R2Fhtj1aP209NktSAOgvwS4H3\nR8Qs8MKIeA8wB+ys9m8FDvRZkyQ1oJt7Cj8iM3/68HZEzGbm9RFxJnBPRFwEnAt8nvYlobo1SVID\nuj5TyMzW0WqZ+ShwGfAgcGlmPtVPrb+XJEmqq+czhaPJzMeA3atVkyStPW/qSpIKQ0GSVBgKkqTC\nUJAkFat2o1mStPrOmtpTtm/fNXKMkavDMwVJUmEoSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEg\nSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTAUJEmFoSBJKgwFSVLRVShExFhE7K22nxcRsxHx\nDxExHW0bIuLuiHgwIq6txtWuSZKa0TEUImIzcAdw+P8D95vAGzPzEuAM4DzgOmAuMy8EroqIU/qs\nSZIaEJl57AERzwICuCszW8v2fQF4JfBhYCozvxYRU8DngbfUrWXm/cueZxKYBBgbG9s2MzNT68Uu\nLi4yOjpa69hBsq/e2FfvhrU3++ps//xC2T5707rafU1MTMxl5ninces7DcjMQwAR8SP1iHgV8C+Z\n+VhEjADz1a6DwBjtM4u6teU9TAPTAOPj49lqtTq1vaLZ2VnqHjtI9tUb++rdsPZmX51dM7WnbN++\na2TgfdW60RwR5wC/B/xuVVoENlbbo9Xj9lOTJDWg5wW4usfwMeDazDx8XjMH7Ky2twIH+qxJkhrQ\n8fLRCqaA5wG3VJeU3kn7RvQ9EXERcC7tewXzfdQkSQ3o+kzh8E3mzHxbZj43M1vV1+cy81HgMuBB\n4NLMfKqf2qq+QklS1+qcKawoMx8Ddq9WTZK09rypK0kqDAVJUmEoSJIKQ0GSVBgKkqTCUJAkFYaC\nJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTAUJEmFoSBJKgwFSVJhKEiSCkNB\nklQYCpKkwlCQJBVdhUJEjEXE3mp7Q0TcHREPRsS1g6hJkprRMRQiYjNwBzBSla4D5jLzQuCqiDhl\nADVJUgMiM489IOJZQAB3ZWYrIj4FTGXm1yJiCvg88JbVrGXm/ct6mAQmAcbGxrbNzMzUerGLi4uM\njo7WOnaQ7Ks39tW7Ye3NvjrbP79Qts/etK52XxMTE3OZOd5p3PpOAzLzEEBEHC6NAPPV9kFgbAC1\n5T1MA9MA4+Pj2Wq1OrW9otnZWeoeO0j21Rv76t2w9mZfnV0ztads375rZOB91bnRvAhsrLZHq8dY\n7ZokqQF1FuA5YGe1vRU4MICaJKkBHS8freAO4J6IuAg4l/Z9gflVrkmSGtD1mUJmtqr/PgpcBjwI\nXJqZT612bfVeniSpF3XOFMjMx4Ddg6xJktaeN3UlSYWhIEkqDAVJUmEoSJIKQ0GSVBgKkqTCUJAk\nFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqTAUJEmFoSBJKgwFSVJhKEiS\nCkNBklQYCpKkoudQiIjNEXFPRDwcEX9W1W6LiH0Rcf2ScbVrkqRm1DlTeB1wZ2aOA6dExO8D6zJz\nB3BORGyJiCvr1lbpdUmSaojM7O2AiKuB5wPvB+4GvgrcnZn3RMSrgY3A+cDf1all5kdWeM5JYBJg\nbGxs28zMTK0Xu7i4yOjoaK1jB8m+emNfvRvW3uyrs/3zC2X77E3ravc1MTExV/1j/pjW13jsfwRe\nBvwO8K/AycB8te8gcAEw0kftaTJzGpgGGB8fz1arVaNtmJ2dpe6xg2RfvbGv3g1rb/bV2TVTe8r2\n7btGBt5XnctH7wR+KzPfDfwb8Bra/+oHGK0ec7GPmiSpIXUW4c3AeRGxDngxcAOws9q3FTgAzPVR\nkyQ1pM7loz8EPgKcCewD/hjYGxGnAVcA24HsoyZJakjPZwqZ+YXM/NnMHM3MyzLzENACHgImMnOh\nn9pqvChJUj11zhSeJjOfBHavVk2S1Axv7EqSCkNBklQYCpKkwlCQJBWGgiSpMBQkSYWhIEkqDAVJ\nUmEoSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIk\nqTAUJElF7VCIiFsj4uXV9m0RsS8irl+yv3ZN0olh//wCZ03t4aypPU23okqtUIiIi4Cfysy7I+JK\nYF1m7gDOiYgt/dRW6XVJkmroORQiYgPw58CBiPgloAXsrnbfB+zssyZJakhkZm8HRLweeBnwJuA6\nYAq4IDMfiYjLgQuALcDNdWqZecMKzzkJTAKMjY1tm5mZqfViFxcXGR0drXXsINlXb+yrd8Pa2xMH\nF/jW99vb552+qdlmlhim+do/v1C2z960rnZfExMTc5k53mnc+hqPfT4wnZmPR8RfAS8BNlb7Rmmf\nfSz2UXuazJwGpgHGx8ez1WrVaBtmZ2epe+wg2Vdv7Kt3w9rbLXfexY3728vQgatbzTazxDDN1zVL\n7rfcvmtk4H3VuafwH8A51fY4cBZHLvtsBQ4Ac33UJEkNqXOmcBvwlxHxamAD7fsCn4qI04ArgO1A\nAntr1iRJDen5TCEzv5uZv5qZF2fmjsx8lHYwPARMZOZCZh6qW1uNFyVJqqfOmcLTZOaTHHkXUd81\nSVIz/ItmSVJhKEiSCkNBklQYCpKkwlCQJBWGgiSpMBQkSYWhIEkqDAVJUmEoSJIKQ0GSVBgKkqTC\nUJAkFYaCJKkwFCRJhaEgSSoMBUlSYShIkgpDQZJUGAqSpMJQkCQVhoIkqagdChExFhFfrrZvi4h9\nEXH9kv21a5KkZvRzpvABYGNEXAmsy8wdwDkRsaWfWr8vSJJU3/o6B0XEJcD3gMeBFrC72nUfsBM4\nv4/aN+r0JEnqX2RmbwdEnAzcC/wy8EngP4GbM/ORiLgcuADYUreWmTes8JyTwCTA2NjYtpmZmVov\ndnFxkdHR0VrHDpJ99ca+ejesvT1xcIFvfb+9fd7pm5ptZolhmq/98wtl++xN62r3NTExMZeZ453G\n1TlTmAJuzczvRATAIrCx2jdK+5JUP7WnycxpYBpgfHw8W61WjbZhdnaWuscOkn31xr56N6y93XLn\nXdy4v70MHbi61WwzSwzTfF0ztads375rZOB91bmncCnw5oiYBV4IvJz2ZR+ArcABYK6PmiSpIT2f\nKWTmxYe3q2B4BbA3Ik4DrgC2A9lHTZLUkL7+TiEzW5l5iPbN5oeAicxc6KfWTz+SpP7UevfRcpn5\nJEfeRdR3TZLUDP+iWZJUGAqSpMJQkCQVhoIkqTAUJEmFoSBJKgwFSVJhKEiSCkNBklQYCpKkwlCQ\nJBWGgiSpMBQkSYWhIEkqDAVJUmEoSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEgSSp6DoWI2BQR\nn46I+yLiExFxckTcFhH7IuL6JeNq16Rnov3zC5w1tad8Sc9Edc4UrgZuyszLgceBVwPrMnMHcE5E\nbImIK+vWVudlSZLqWN/rAZl565JvTwVeC/xJ9f19wE7gfGB3zdo3eu1JkrQ6IjPrHRixA3gPcAC4\nOTMfiYjLgQuALXVrmXnDCs81CUwCjI2NbZuZmanV8+LiIqOjo7WOHST76s2w9vXEwQW+9f0j3593\n+qbmmlnmmTBnztfK9s8vlO2zN62r3dfExMRcZo53GtfzmQJARDwbuAX4FeCtwMZq1yjtS1KLfdSe\nJjOngWmA8fHxbLVaddpmdnaWuscOkn31Zlj7uuXOu7hx/5FfqQNXt5prZplnwpw5Xyu7Zsn9qdt3\njQy8rzo3mk8GPg68PTMfBeZoX/YB2Er7zKGfmiSpIXXOFF5P+9LPOyLiHcBHgNdFxGnAFcB2IIG9\nNWuSpIb0fKaQmX+amZszs1V93QG0gIeAicxcyMxDdWur8aIkSfXUuqewXGY+yZF3EfVdkyQ1w79o\nliQVhoIkqTAUJEmFoSBJKgwFSVJhKEiSCkNBklQYCpKkwlCQJBWGgiSpMBQkSYWhIEkqDAVJUmEo\nSJIKQ0GSVBgKkqTCUJAkFYaCJKkwFCRJhaEgSSoMBUlSYShIkoqhCIWIuC0i9kXE9U33oiP2zy9w\n1tQezpra03QrktZI46EQEVcC6zJzB3BORGwZ1HO5yEnSsTUeCkAL2F1t3wfsbK4VSTqxRWY220DE\nbcDNmflIRFwOXJCZNywbMwlMVt/+DPDvNZ/uOcC3azc7OPbVG/vq3bD2Zl+96aevMzPz1E6D1td8\n8NW0CGystkdZ4ewlM6eB6X6fKCIezszxfh9ntdlXb+yrd8Pam331Zi36GobLR3McuWS0FTjQXCuS\ndGIbhjOFTwJ7I+I04Apge8P9SNIJq/Ezhcw8RPtm80PARGYuDPDp+r4ENSD21Rv76t2w9mZfvRl4\nX43faJYkDY/GzxQkrY6IeHZEXBYRz2m6Fz1zGQprLCLGImLvMfafHhHfjIjZ6qvjW8iORxGxKSI+\nHRH3RcQnIuLkFcasj4j/WTJX561Rb0O3+EbEZuBvgRcB96/0c9PUfA2z6vfxy0fZd0LO13EbCl0s\nvhsi4u6IeDAirl2jnjYDdwAjxxj2YuC9mdmqvv5vwD11XHyrcWv9USRXAzdl5uXA48CuFca8APjY\nkrnaP+imull8q3FrPV8vAN6ame8F7gUuOMqYNZ2vw461+Fb7m/qomw9w5C3xyzXx89VVEEXEuyLi\nixHxodXu4bgMhS4X3+uAucy8ELgqIk5Zg9aeAl4FHDrGmO3AGyLiSxHxvjXoqePiu5YfRXJYZt6a\nmZ+pvj0VeGKFYduBX4yIL1SLylq8m67j4tvQfH0uMx+KiItpB9a+FYY1MV+HHXXxbWK+que9BPge\n7Z/7lTT183XMIIqIbbTfxv8i4ImIuHQ1GzguQ4HuFt8WRz5e4wFg4H+okpmHunh31adp9/ZzwI6I\neMGAe+pm8W3R0EeRRMQOYHNmPrTC7i8Cl2bmi4ANwC8Mup8uF98WDcxXRATtn/sngR+sMGTN56vq\nq9Pi22KN56s6I/4DYOoYw5qYr26C6KXA32T7XUL3AhetZgPHZSh0ufiOAPPV9kFgbLBdde2fMvO7\nmfkU8GVgrf7VdKzFt5G5iohnA7cAR7u895XM/N9q+2HWbq46Lb6NzFe2vRn4CvCKFYas+Xx1ufg2\nMV9TwK2Z+Z1jjGni56ubIBrofB2XodCljh+v0ZB7I+K5EfHjwOXAVwf9hF0svms+V9Vi8nHg7Zn5\n6FGGfTQitkbEOuCVwCOD7gu6WnybmK+3RcSvV9/+BLDSYtfEfHWz+Dbxu3gp8OaImAVeGBF/scKY\nJuarmyAa6HwNy0LYhMY/XiMiLomI315WfhdwP+0/5vtwZtb98L9ue+hm8W1irl5P+3r9O6obbu+M\niPcsG/Nu4KPAPwP7MvOzg26qy8W3ifmaBl4XEQ8A64BvDsN80d3iu+bzlZkXH75uT3s+bhqS+eom\niAY6X8f1H69FxGxmtqprmudm5geX7DsTuAf4LPASYHt1yeaEEhFvBN7HkR+++4ENmXn9kjHPAvYC\nf0/1USQD/svzoVW9iWE38GO0z+I+BPya89VZFQxvAl7jfK0sIp4P/DUQwKeAG4E/ysw3LBlzEu35\nepj2G0N2ZeZ/r1oPx3ModBLtz1vaCdx7ov4QdqtaDC8DHsjMo90wVMX56o3z1ZuI2Ai8DPhSZv7X\nqj72iRwKkqQfdSLfU5AkLWMoSJIKQ0GSVBgKkqTCUJAkFf8PjQQKiJdGCDkAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f0601ca5be0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_train['Score'].hist(bins=100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Id</th>\n",
       "      <th>Discuss</th>\n",
       "      <th>Score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>5c3aebd3-6a1b-329e-8ab4-c8c396aaf299</td>\n",
       "      <td>演出</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>8b551fdf-97b0-3cdb-8d78-1d1578ba24bc</td>\n",
       "      <td>水里有寄生虫。大家小心。不能引用洗手，绝对不能下水！</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>4a64ade3-8794-3fa6-88fc-3cd5bd3820cc</td>\n",
       "      <td>纯商业化，有时候还会80元古城维护费，我的天，抢钱吗</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581</th>\n",
       "      <td>ace977e7-80ed-3fa7-820e-564fc6fa85c4</td>\n",
       "      <td>一星都不想给。想去黄山很久了，难得十一假期可以自驾过来，第一天到得有些晚了，售票点姐姐建议我...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>875</th>\n",
       "      <td>4a7d8012-ec71-34cd-9ca6-5d08085363dd</td>\n",
       "      <td>很幸运的看到了长白山天池。因为大雾，据说去长白山80%的人都看不见。</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>926</th>\n",
       "      <td>5b009aed-7066-3286-b9d0-17669aa1c1c5</td>\n",
       "      <td>门票贵 里面什么设施都没有 桌椅坐一下就要150块 垃圾到处扔 海水还很脏 你收费就该整治下...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1032</th>\n",
       "      <td>5e53bfbe-506b-34d0-9fbb-78bbe9a89f18</td>\n",
       "      <td>当时好像在拍戏，没有开放，在梦幻谷里面</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1061</th>\n",
       "      <td>945c6b0e-d47b-3aee-8fb6-0ac6292539e1</td>\n",
       "      <td>新建的，没有多少意思，门票也超级贵，所以没有选择进入，个人也并不推荐，长江四大名楼。阅江楼、...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1157</th>\n",
       "      <td>4dc21ba1-cdcc-3678-8fa7-9938ca1dcee4</td>\n",
       "      <td>这个地方，简直是太坑爹。。。只有一层地下，展品也主要是瓦当和封泥，介绍也不是很有趣，说是古陶...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1389</th>\n",
       "      <td>60d461af-1b8d-38b8-ac02-68605fb81d11</td>\n",
       "      <td>感觉最差的一次旅行,风景秀丽但当地民风不太好，成都南门车站买的车票说好30分钟发车，结果从6...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1406</th>\n",
       "      <td>5106f806-2aae-3b3e-ae69-ca3403aeb3f7</td>\n",
       "      <td>索道太贵了100块钱，还有大巴30一位就不能便宜一些。</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1702</th>\n",
       "      <td>192aacc1-5462-31eb-a991-0b069d13fa3e</td>\n",
       "      <td>西单聚集了很多商场，在西单商场买特产还行。</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1848</th>\n",
       "      <td>5bf47ddd-ebd7-3612-a209-88d8e3aa2072</td>\n",
       "      <td>景色还好，就在一环看看就可以了，赶紧回头排云亭，要是和我们傻乎乎的走到谷底，一路往下风景一路...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2096</th>\n",
       "      <td>f6d50fce-9d3d-33b9-9b02-68e9589aa212</td>\n",
       "      <td>景色还好，就在一环看看就可以了，赶紧回头排云亭，要是和我们傻乎乎的走到谷底，一路往下风景一路...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2127</th>\n",
       "      <td>cc1f4ddc-f9e8-3220-8ee5-53f8d97277e2</td>\n",
       "      <td>太差劲了</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2218</th>\n",
       "      <td>4627f657-e5d4-3535-8b9c-e9ca1ac434b4</td>\n",
       "      <td>充分利用原址修建的噱头尽骗人之能事。120元的价格和北京的圆明园遗址公园相比简直是差几个世纪...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2289</th>\n",
       "      <td>29d69b44-b913-3121-b7e9-e82a8073299d</td>\n",
       "      <td>去过最糟心的一个景点 工作人员服务态度不好 话都没说完直接嚷嚷又误导人 小贩简直哔了狗了 景...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2503</th>\n",
       "      <td>28d767d6-55e7-3d39-9dfa-cca30beb7182</td>\n",
       "      <td>就是一般</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2524</th>\n",
       "      <td>2def7a60-182c-3992-aaff-76413ee9c815</td>\n",
       "      <td>只能说 差差差 重要的事说三遍 除了风景不错 其他的都太黑了 坑的一塌糊涂 早上在寨西吃了一...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2778</th>\n",
       "      <td>03dd8360-6f72-329f-acc3-48f791316976</td>\n",
       "      <td>呵呵这是我们所有城规老师都呵呵的地方&lt;br /&gt;rn为了景观而景观，造旧如旧，而且吃的都没人买……</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2928</th>\n",
       "      <td>dbf01db3-49fb-33b4-bdf7-2466a7483cfd</td>\n",
       "      <td>路过 一般般吧</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3179</th>\n",
       "      <td>a21fbf68-01ab-3be5-94db-8ebd02bc8bce</td>\n",
       "      <td>西面那块的园子没什么可看的而且太寂静了[大汗]基本没人</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3281</th>\n",
       "      <td>c579d386-e5b7-3217-95d5-4fdeb63087aa</td>\n",
       "      <td>非常差的一个地方，打车都打不到，好不容易打到一个车，真是坑死人</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3283</th>\n",
       "      <td>ceaf67d3-30db-34e3-90aa-fc2e79447c47</td>\n",
       "      <td>很糟糕的一次旅游，下面我向大家讲下我在王府井游玩的经历无意间走进了一家饰品店，那里有各种佩戴...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3518</th>\n",
       "      <td>479c0916-8078-37e6-a262-9a0378dcd5d5</td>\n",
       "      <td>故宫很漂亮，新开的后宫部分很有历史感。&lt;br /&gt;n不能走回头路，但是旺季的时候规划的很不好...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4572</th>\n",
       "      <td>e3b88943-c812-3ec7-9e4e-4fa9d9b6ddcd</td>\n",
       "      <td>排队</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4598</th>\n",
       "      <td>df0fd327-c835-3949-a7bc-e10454a9da71</td>\n",
       "      <td>差评，封禅大典很一般，美团很坑人，还要去换票，很不方便</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4931</th>\n",
       "      <td>9f6dd80c-5299-3828-a2d0-deaf0cd71c1e</td>\n",
       "      <td>又累又冷，山上的食物呀……有没有物价局监管</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4946</th>\n",
       "      <td>ae3e78fe-165f-3fed-b1e7-c665741f9d22</td>\n",
       "      <td>没登陆状态在百度定了三张票，收到提示三张出票成功，但没有任何编号或者什么二维码什么的，然后接...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5821</th>\n",
       "      <td>1d32702c-24df-34cc-944b-2a040211718f</td>\n",
       "      <td>切记，我也被骗了，星期一闭馆</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216429</th>\n",
       "      <td>4c6ee0cf-a508-3154-8440-c645fbf50181</td>\n",
       "      <td>近距离看这个塔，还是斑斑驳驳的，年久失修啊。</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216438</th>\n",
       "      <td>60dc1b44-d6f0-363d-94f1-fe336298629d</td>\n",
       "      <td>五大连池市，五大连市风景区极差评！今天打出租车去五大连池老黑山景区，结果出租车司机把我送了堰...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216451</th>\n",
       "      <td>c9c80b22-5dc1-3fe3-81fe-19dd77a86389</td>\n",
       "      <td>非常差，不会再去第二次！大家也不要去！</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216489</th>\n",
       "      <td>48f72e20-9976-3cbe-95f9-61b915cdee9b</td>\n",
       "      <td>中国第一秋景真的很美，只可惜景区的运营管理不能更垃圾，禁止社会车辆进入，强制将游客聚集起来排...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216514</th>\n",
       "      <td>3c279c16-0bcf-3cda-9d09-4574ab3484e2</td>\n",
       "      <td>服务一塌糊涂，景色没有，除了日出日落看下几分钟，其他一无是处，不推荐。</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216517</th>\n",
       "      <td>7ceaf8aa-51f3-301d-add5-6a8035b1a4bc</td>\n",
       "      <td>和十年前一样。不一样的是，椅子坐一会一百，在那个浮在水上的泡沫搭起来的排子上站一下就要被赶下...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216570</th>\n",
       "      <td>f4088b74-4857-379a-874d-599dc17d95f6</td>\n",
       "      <td>还比不上桂林的罗湖山水上乐园，没什么的，里面的设施一般水上乐园都有，很失望，几百元的门票啊</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216846</th>\n",
       "      <td>ad1b1f8f-813c-31fa-a23a-a4bb75eb36cc</td>\n",
       "      <td>国庆没地方去同学说要不附件走走选来选去就选了衡山然而十分失望山底下排了三个小时的队买票上山一...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216857</th>\n",
       "      <td>fd63cccc-f105-3b9c-9387-92c318a6e4af</td>\n",
       "      <td>呵呵，一人50，来大兴安岭看观音，司机是真能忽悠啊，看我们外地人人生地不熟，一脚油门就把我们...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216873</th>\n",
       "      <td>d6afb747-ed8e-3186-9407-11ff6cdd89c9</td>\n",
       "      <td>老人票不提醒</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216913</th>\n",
       "      <td>2974a719-c109-33f3-8d82-2bc575be196d</td>\n",
       "      <td>【地址】751D·PARK北京时尚设计广场 地址（Add）：北京市朝阳区酒仙桥路4号</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217058</th>\n",
       "      <td>0142a602-396f-3417-81ae-28225d76a75f</td>\n",
       "      <td>坑爹的景点，此生不会再去，当你走进大门后就有种被骗的感觉</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217236</th>\n",
       "      <td>95ccb16a-dfb4-3850-9020-a0f21ffe80b4</td>\n",
       "      <td>曾经在长辈口中称颂的，如今已经荡然无存，到处是人造景观，当年看绿浪翻滚葡萄沟的地方已经不让去了。</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217251</th>\n",
       "      <td>d5539132-32b4-32cb-abf8-d6c8b1582a6a</td>\n",
       "      <td>没去的时候还是满期待的，毕竟也是个几A的风景区。不过去了之后，只想说，生态真的是很差，所谓的...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217539</th>\n",
       "      <td>02f992d0-5849-34c8-9692-db89c51057c7</td>\n",
       "      <td>景是不错，就是到南天门后，贼坑，在上面吃碗拉面贼难吃，10块钱还行，就是在上面有点冷，他们还...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217807</th>\n",
       "      <td>86ede701-5518-33cd-af33-b627ec466ef2</td>\n",
       "      <td>一开始就是冲着过山车去的，到了居然不能玩，还有很多设施都不能玩，差评，游乐项目太少，不值这个价格</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217927</th>\n",
       "      <td>30c6eb28-b728-30f7-b1a0-455afedeedd8</td>\n",
       "      <td>景区内全在整修，路也乱七八糟的，性价比低到极点，绕一圈就出来了，整修期怎么可以营业卖票？？？</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218298</th>\n",
       "      <td>8de6893f-99f1-3996-a74d-f240d0ccce32</td>\n",
       "      <td>我去过，环境不错，当时票价是50，现在听说休的更好了</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218306</th>\n",
       "      <td>4f9c3874-cda5-312e-b26e-57ed7efc72ea</td>\n",
       "      <td>冬天是她们最美的地方，但是要想看见雾凇也是需要运气的</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218691</th>\n",
       "      <td>e43b9d45-2411-3f60-b42c-a8361dfbeca1</td>\n",
       "      <td>真是一个坑</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218986</th>\n",
       "      <td>2cddff9c-f24b-3ae5-a0c1-4148b0556fdf</td>\n",
       "      <td>今天早上7点起床就到索道那排队，我在网上订的b线路票，接着开始排队做公交车，排到我的时候已经...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219052</th>\n",
       "      <td>fce7784a-c5c6-38c6-8724-e4cb0f33d93a</td>\n",
       "      <td>比较失望，地方不大，大部分都是现代建的，不好玩！</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219174</th>\n",
       "      <td>12a6abf7-7da5-35da-b3f4-13076c3b6f5e</td>\n",
       "      <td>广告是做得十足，演出实在是看不下去！建议去泰山的朋友不要去。先说演出，第一：舞蹈演员一不化妆...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219409</th>\n",
       "      <td>6488360d-21c7-378d-a328-37a325983b26</td>\n",
       "      <td>只有山哪来的瀑布，伤心，开了单边700公里。不如九寨那个沟沟。一点都不好玩，不知道怎么那么多...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219422</th>\n",
       "      <td>f7e42a3f-9b22-3eff-b3fa-ab3b7acc3611</td>\n",
       "      <td>第二次来西湖～给我的感觉还是一如既往的乱差！这次带家人自驾游过来～遇到交通管制先是单双号限行...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219473</th>\n",
       "      <td>7a113575-5780-32f3-b979-763be912e6ed</td>\n",
       "      <td>晚上一点从红门登山，到中天门时本以为走完了大半，谁知才仅仅是三分之一，最好不要走的太快，否则...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219576</th>\n",
       "      <td>13e93198-b478-3319-ad23-ba4b8dc8a18c</td>\n",
       "      <td>迄今为止最差的一次旅游，晚上爬山一路上人多的水泄不通。晚上12点开始爬5点到的日观峰，人多的...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219656</th>\n",
       "      <td>bdb263e1-57b4-3c53-bacd-6e739616be27</td>\n",
       "      <td>天啦。这个水磨古镇也能叫景区？？？？？？？现代化太严重。还修了游客中心。不知道有什么旅游价值...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219872</th>\n",
       "      <td>6e54b476-0c30-37a4-a777-e7ce276bff56</td>\n",
       "      <td>都已经关闭此岛了，为什么不删除。</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219887</th>\n",
       "      <td>fa3e4aa9-2645-305a-a0c8-45c63dcf6c94</td>\n",
       "      <td>从来不写评价的。这次忍不住了。&lt;br /&gt;去长城选择的是s2火车。北京北站，进去刷公交卡，到...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1224 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          Id  \\\n",
       "24      5c3aebd3-6a1b-329e-8ab4-c8c396aaf299   \n",
       "201     8b551fdf-97b0-3cdb-8d78-1d1578ba24bc   \n",
       "358     4a64ade3-8794-3fa6-88fc-3cd5bd3820cc   \n",
       "581     ace977e7-80ed-3fa7-820e-564fc6fa85c4   \n",
       "875     4a7d8012-ec71-34cd-9ca6-5d08085363dd   \n",
       "926     5b009aed-7066-3286-b9d0-17669aa1c1c5   \n",
       "1032    5e53bfbe-506b-34d0-9fbb-78bbe9a89f18   \n",
       "1061    945c6b0e-d47b-3aee-8fb6-0ac6292539e1   \n",
       "1157    4dc21ba1-cdcc-3678-8fa7-9938ca1dcee4   \n",
       "1389    60d461af-1b8d-38b8-ac02-68605fb81d11   \n",
       "1406    5106f806-2aae-3b3e-ae69-ca3403aeb3f7   \n",
       "1702    192aacc1-5462-31eb-a991-0b069d13fa3e   \n",
       "1848    5bf47ddd-ebd7-3612-a209-88d8e3aa2072   \n",
       "2096    f6d50fce-9d3d-33b9-9b02-68e9589aa212   \n",
       "2127    cc1f4ddc-f9e8-3220-8ee5-53f8d97277e2   \n",
       "2218    4627f657-e5d4-3535-8b9c-e9ca1ac434b4   \n",
       "2289    29d69b44-b913-3121-b7e9-e82a8073299d   \n",
       "2503    28d767d6-55e7-3d39-9dfa-cca30beb7182   \n",
       "2524    2def7a60-182c-3992-aaff-76413ee9c815   \n",
       "2778    03dd8360-6f72-329f-acc3-48f791316976   \n",
       "2928    dbf01db3-49fb-33b4-bdf7-2466a7483cfd   \n",
       "3179    a21fbf68-01ab-3be5-94db-8ebd02bc8bce   \n",
       "3281    c579d386-e5b7-3217-95d5-4fdeb63087aa   \n",
       "3283    ceaf67d3-30db-34e3-90aa-fc2e79447c47   \n",
       "3518    479c0916-8078-37e6-a262-9a0378dcd5d5   \n",
       "4572    e3b88943-c812-3ec7-9e4e-4fa9d9b6ddcd   \n",
       "4598    df0fd327-c835-3949-a7bc-e10454a9da71   \n",
       "4931    9f6dd80c-5299-3828-a2d0-deaf0cd71c1e   \n",
       "4946    ae3e78fe-165f-3fed-b1e7-c665741f9d22   \n",
       "5821    1d32702c-24df-34cc-944b-2a040211718f   \n",
       "...                                      ...   \n",
       "216429  4c6ee0cf-a508-3154-8440-c645fbf50181   \n",
       "216438  60dc1b44-d6f0-363d-94f1-fe336298629d   \n",
       "216451  c9c80b22-5dc1-3fe3-81fe-19dd77a86389   \n",
       "216489  48f72e20-9976-3cbe-95f9-61b915cdee9b   \n",
       "216514  3c279c16-0bcf-3cda-9d09-4574ab3484e2   \n",
       "216517  7ceaf8aa-51f3-301d-add5-6a8035b1a4bc   \n",
       "216570  f4088b74-4857-379a-874d-599dc17d95f6   \n",
       "216846  ad1b1f8f-813c-31fa-a23a-a4bb75eb36cc   \n",
       "216857  fd63cccc-f105-3b9c-9387-92c318a6e4af   \n",
       "216873  d6afb747-ed8e-3186-9407-11ff6cdd89c9   \n",
       "216913  2974a719-c109-33f3-8d82-2bc575be196d   \n",
       "217058  0142a602-396f-3417-81ae-28225d76a75f   \n",
       "217236  95ccb16a-dfb4-3850-9020-a0f21ffe80b4   \n",
       "217251  d5539132-32b4-32cb-abf8-d6c8b1582a6a   \n",
       "217539  02f992d0-5849-34c8-9692-db89c51057c7   \n",
       "217807  86ede701-5518-33cd-af33-b627ec466ef2   \n",
       "217927  30c6eb28-b728-30f7-b1a0-455afedeedd8   \n",
       "218298  8de6893f-99f1-3996-a74d-f240d0ccce32   \n",
       "218306  4f9c3874-cda5-312e-b26e-57ed7efc72ea   \n",
       "218691  e43b9d45-2411-3f60-b42c-a8361dfbeca1   \n",
       "218986  2cddff9c-f24b-3ae5-a0c1-4148b0556fdf   \n",
       "219052  fce7784a-c5c6-38c6-8724-e4cb0f33d93a   \n",
       "219174  12a6abf7-7da5-35da-b3f4-13076c3b6f5e   \n",
       "219409  6488360d-21c7-378d-a328-37a325983b26   \n",
       "219422  f7e42a3f-9b22-3eff-b3fa-ab3b7acc3611   \n",
       "219473  7a113575-5780-32f3-b979-763be912e6ed   \n",
       "219576  13e93198-b478-3319-ad23-ba4b8dc8a18c   \n",
       "219656  bdb263e1-57b4-3c53-bacd-6e739616be27   \n",
       "219872  6e54b476-0c30-37a4-a777-e7ce276bff56   \n",
       "219887  fa3e4aa9-2645-305a-a0c8-45c63dcf6c94   \n",
       "\n",
       "                                                  Discuss  Score  \n",
       "24                                                     演出      1  \n",
       "201                            水里有寄生虫。大家小心。不能引用洗手，绝对不能下水！      1  \n",
       "358                            纯商业化，有时候还会80元古城维护费，我的天，抢钱吗      1  \n",
       "581     一星都不想给。想去黄山很久了，难得十一假期可以自驾过来，第一天到得有些晚了，售票点姐姐建议我...      1  \n",
       "875                    很幸运的看到了长白山天池。因为大雾，据说去长白山80%的人都看不见。      1  \n",
       "926     门票贵 里面什么设施都没有 桌椅坐一下就要150块 垃圾到处扔 海水还很脏 你收费就该整治下...      1  \n",
       "1032                                  当时好像在拍戏，没有开放，在梦幻谷里面      1  \n",
       "1061    新建的，没有多少意思，门票也超级贵，所以没有选择进入，个人也并不推荐，长江四大名楼。阅江楼、...      1  \n",
       "1157    这个地方，简直是太坑爹。。。只有一层地下，展品也主要是瓦当和封泥，介绍也不是很有趣，说是古陶...      1  \n",
       "1389    感觉最差的一次旅行,风景秀丽但当地民风不太好，成都南门车站买的车票说好30分钟发车，结果从6...      1  \n",
       "1406                          索道太贵了100块钱，还有大巴30一位就不能便宜一些。      1  \n",
       "1702                                西单聚集了很多商场，在西单商场买特产还行。      1  \n",
       "1848    景色还好，就在一环看看就可以了，赶紧回头排云亭，要是和我们傻乎乎的走到谷底，一路往下风景一路...      1  \n",
       "2096    景色还好，就在一环看看就可以了，赶紧回头排云亭，要是和我们傻乎乎的走到谷底，一路往下风景一路...      1  \n",
       "2127                                                 太差劲了      1  \n",
       "2218    充分利用原址修建的噱头尽骗人之能事。120元的价格和北京的圆明园遗址公园相比简直是差几个世纪...      1  \n",
       "2289    去过最糟心的一个景点 工作人员服务态度不好 话都没说完直接嚷嚷又误导人 小贩简直哔了狗了 景...      1  \n",
       "2503                                                 就是一般      1  \n",
       "2524    只能说 差差差 重要的事说三遍 除了风景不错 其他的都太黑了 坑的一塌糊涂 早上在寨西吃了一...      1  \n",
       "2778    呵呵这是我们所有城规老师都呵呵的地方<br />rn为了景观而景观，造旧如旧，而且吃的都没人买……      1  \n",
       "2928                                              路过 一般般吧      1  \n",
       "3179                          西面那块的园子没什么可看的而且太寂静了[大汗]基本没人      1  \n",
       "3281                      非常差的一个地方，打车都打不到，好不容易打到一个车，真是坑死人      1  \n",
       "3283    很糟糕的一次旅游，下面我向大家讲下我在王府井游玩的经历无意间走进了一家饰品店，那里有各种佩戴...      1  \n",
       "3518    故宫很漂亮，新开的后宫部分很有历史感。<br />n不能走回头路，但是旺季的时候规划的很不好...      1  \n",
       "4572                                                   排队      1  \n",
       "4598                          差评，封禅大典很一般，美团很坑人，还要去换票，很不方便      1  \n",
       "4931                                又累又冷，山上的食物呀……有没有物价局监管      1  \n",
       "4946    没登陆状态在百度定了三张票，收到提示三张出票成功，但没有任何编号或者什么二维码什么的，然后接...      1  \n",
       "5821                                       切记，我也被骗了，星期一闭馆      1  \n",
       "...                                                   ...    ...  \n",
       "216429                             近距离看这个塔，还是斑斑驳驳的，年久失修啊。      1  \n",
       "216438  五大连池市，五大连市风景区极差评！今天打出租车去五大连池老黑山景区，结果出租车司机把我送了堰...      1  \n",
       "216451                                非常差，不会再去第二次！大家也不要去！      1  \n",
       "216489  中国第一秋景真的很美，只可惜景区的运营管理不能更垃圾，禁止社会车辆进入，强制将游客聚集起来排...      1  \n",
       "216514                服务一塌糊涂，景色没有，除了日出日落看下几分钟，其他一无是处，不推荐。      1  \n",
       "216517  和十年前一样。不一样的是，椅子坐一会一百，在那个浮在水上的泡沫搭起来的排子上站一下就要被赶下...      1  \n",
       "216570      还比不上桂林的罗湖山水上乐园，没什么的，里面的设施一般水上乐园都有，很失望，几百元的门票啊      1  \n",
       "216846  国庆没地方去同学说要不附件走走选来选去就选了衡山然而十分失望山底下排了三个小时的队买票上山一...      1  \n",
       "216857  呵呵，一人50，来大兴安岭看观音，司机是真能忽悠啊，看我们外地人人生地不熟，一脚油门就把我们...      1  \n",
       "216873                                             老人票不提醒      1  \n",
       "216913         【地址】751D·PARK北京时尚设计广场 地址（Add）：北京市朝阳区酒仙桥路4号      1  \n",
       "217058                       坑爹的景点，此生不会再去，当你走进大门后就有种被骗的感觉      1  \n",
       "217236   曾经在长辈口中称颂的，如今已经荡然无存，到处是人造景观，当年看绿浪翻滚葡萄沟的地方已经不让去了。      1  \n",
       "217251  没去的时候还是满期待的，毕竟也是个几A的风景区。不过去了之后，只想说，生态真的是很差，所谓的...      1  \n",
       "217539  景是不错，就是到南天门后，贼坑，在上面吃碗拉面贼难吃，10块钱还行，就是在上面有点冷，他们还...      1  \n",
       "217807   一开始就是冲着过山车去的，到了居然不能玩，还有很多设施都不能玩，差评，游乐项目太少，不值这个价格      1  \n",
       "217927     景区内全在整修，路也乱七八糟的，性价比低到极点，绕一圈就出来了，整修期怎么可以营业卖票？？？      1  \n",
       "218298                         我去过，环境不错，当时票价是50，现在听说休的更好了      1  \n",
       "218306                         冬天是她们最美的地方，但是要想看见雾凇也是需要运气的      1  \n",
       "218691                                              真是一个坑      1  \n",
       "218986  今天早上7点起床就到索道那排队，我在网上订的b线路票，接着开始排队做公交车，排到我的时候已经...      1  \n",
       "219052                           比较失望，地方不大，大部分都是现代建的，不好玩！      1  \n",
       "219174  广告是做得十足，演出实在是看不下去！建议去泰山的朋友不要去。先说演出，第一：舞蹈演员一不化妆...      1  \n",
       "219409  只有山哪来的瀑布，伤心，开了单边700公里。不如九寨那个沟沟。一点都不好玩，不知道怎么那么多...      1  \n",
       "219422  第二次来西湖～给我的感觉还是一如既往的乱差！这次带家人自驾游过来～遇到交通管制先是单双号限行...      1  \n",
       "219473  晚上一点从红门登山，到中天门时本以为走完了大半，谁知才仅仅是三分之一，最好不要走的太快，否则...      1  \n",
       "219576  迄今为止最差的一次旅游，晚上爬山一路上人多的水泄不通。晚上12点开始爬5点到的日观峰，人多的...      1  \n",
       "219656  天啦。这个水磨古镇也能叫景区？？？？？？？现代化太严重。还修了游客中心。不知道有什么旅游价值...      1  \n",
       "219872                                   都已经关闭此岛了，为什么不删除。      1  \n",
       "219887  从来不写评价的。这次忍不住了。<br />去长城选择的是s2火车。北京北站，进去刷公交卡，到...      1  \n",
       "\n",
       "[1224 rows x 3 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train[df_train[\"Score\"] == 1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
